home *** CD-ROM | disk | FTP | other *** search
/ Fritz: All Fritz / All Fritz.zip / All Fritz / FILES / UTILENUS / SLIC.LZH / SAMPLE.CLC < prev    next >
Text File  |  1986-09-03  |  10KB  |  392 lines
  1. C,1,11,0,0,T,This Sample
  2. D,1,11,0,0,T, Spread She
  3. E,1,11,0,0,T,et shows ex
  4. F,1,11,0,0,T,ample funct
  5. G,1,11,0,0,T,ions:
  6. D,3,11,0,0,T,The CHOOSE 
  7. E,3,11,0,0,T,Function:
  8. C,5,11,0,0,T,The Choose 
  9. D,5,11,0,0,T,Function wi
  10. E,5,11,0,0,T,ll find a v
  11. F,5,11,0,0,T,alue within
  12. G,5,11,0,0,T, a list of 
  13. H,5,11,0,0,T,numbers.
  14. C,6,11,0,0,T,The list mu
  15. D,6,11,0,0,T,st be conti
  16. E,6,11,0,0,T,nuous in a 
  17. F,6,11,0,0,T,column. Our
  18. G,6,11,0,0,T, sample lis
  19. H,6,11,0,0,T,t is
  20. C,7,11,0,0,T,in the "A" 
  21. D,7,11,0,0,T,column from
  22. E,7,11,0,0,T, row "10" t
  23. F,7,11,0,0,T,hru "20". T
  24. G,7,11,0,0,T,o find the 
  25. H,7,11,0,0,T,value of
  26. C,8,11,0,0,T,the third i
  27. D,8,11,0,0,T,tem enter n
  28. E,8,11,0,0,T,umber 3 at 
  29. F,8,11,0,0,T,cell "C13"
  30. G,8,11,0,0,T,. The CHOOS
  31. H,8,11,0,0,T,E function
  32. C,9,11,0,0,T,is located 
  33. D,9,11,0,0,T,at cell "D1
  34. E,9,11,0,0,T,3". The val
  35. F,9,11,0,0,T,ue of the 3
  36. G,9,11,0,0,T,rd item wil
  37. H,9,11,0,0,T,l be
  38. A,10,5,100,0,N,100
  39. C,10,11,0,0,T,returned at
  40. D,10,11,0,0,T, cell "D13"
  41. E,10,11,0,0,T,. If the nu
  42. F,10,11,0,0,T,mber 4 is e
  43. G,10,11,0,0,T,ntered then
  44. H,10,11,0,0,T, the value
  45. A,11,5,200,0,N,200
  46. C,11,11,0,0,T,of the 4th 
  47. D,11,11,0,0,T,item is ret
  48. E,11,11,0,0,T,urned.
  49. A,12,5,300,0,N,300
  50. A,13,5,400,0,N,400
  51. C,13,11,4,0,N,4
  52. D,13,11,400,0,N,(CHOOSE(C13,A10:A20)
  53. E,13,11,0,0,T, <- The CHO
  54. F,13,11,0,0,T,OSE functio
  55. G,13,11,0,0,T,n is in Cel
  56. H,13,11,0,0,T,l "D13".
  57. A,14,5,500,0,N,500
  58. C,14,11,0,0,T,Enter a num
  59. D,14,11,0,0,T,ber
  60. E,14,11,0,0,T,    The CHO
  61. F,14,11,0,0,T,OSE number 
  62. G,14,11,0,0,T,is in cell 
  63. H,14,11,0,0,T,"C13".
  64. A,15,5,600,0,N,600
  65. C,15,11,0,0,T,between 1 a
  66. D,15,11,0,0,T,nd
  67. A,16,5,700,0,N,700
  68. C,16,11,0,0,T,10 in cell 
  69. D,16,11,0,0,T,"C13".
  70. E,16,11,0,0,T,The CHOOSE 
  71. F,16,11,0,0,T,function ma
  72. G,16,11,0,0,T,y not be us
  73. H,16,11,0,0,T,ed with a
  74. A,17,5,800,0,N,800
  75. E,17,11,0,0,T,formula, bu
  76. F,17,11,0,0,T,t may be re
  77. G,17,11,0,0,T,ferenced as
  78. H,17,11,0,0,T, shown at
  79. A,18,5,900,0,N,900
  80. E,18,11,0,0,T,cell "F18":
  81. F,18,11,4000,0,F,(10 X D13)
  82. A,19,5,1000,0,N,1000
  83. A,20,5,2000,0,N,2000
  84. D,20,11,0,0,T,Press the "
  85. E,20,11,0,0,T,Pg Dn" key 
  86. F,20,11,0,0,T,for next ex
  87. G,20,11,0,0,T,ample.
  88. D,21,11,0,0,T,The LOOKUP 
  89. E,21,11,0,0,T,Function:
  90. C,23,11,0,0,T,The LOOKUP 
  91. D,23,11,0,0,T,function is
  92. E,23,11,0,0,T, similar to
  93. F,23,11,0,0,T, the CHOOSE
  94. G,23,11,0,0,T, function e
  95. H,23,11,0,0,T,xcept
  96. C,24,11,0,0,T,that it loo
  97. D,24,11,0,0,T,ks up the v
  98. E,24,11,0,0,T,alue of the
  99. F,24,11,0,0,T, cell immed
  100. G,24,11,0,0,T,iately to t
  101. H,24,11,0,0,T,he right
  102. C,25,11,0,0,T,of the LOOK
  103. D,25,11,0,0,T,UP number. 
  104. E,25,11,0,0,T,The LOOKUP 
  105. F,25,11,0,0,T,number is t
  106. G,25,11,0,0,T,he key numb
  107. H,25,11,0,0,T,er for 
  108. C,26,11,0,0,T,finding a v
  109. D,26,11,0,0,T,alue. For e
  110. E,26,11,0,0,T,xample the 
  111. F,26,11,0,0,T,key or look
  112. G,26,11,0,0,T, up number 
  113. H,26,11,0,0,T,may be the
  114. C,27,11,0,0,T,age of a pe
  115. D,27,11,0,0,T,rson and th
  116. E,27,11,0,0,T,e look up v
  117. F,27,11,0,0,T,alue may be
  118. G,27,11,0,0,T, a rate.
  119. A,28,5,0,0,T, Age
  120. B,28,6,0.00,2,T, Rate
  121. A,29,5,10,0,N,10
  122. B,29,6,0.95,2,N,0.95
  123. D,29,11,0,0,T,Enter a num
  124. E,29,11,0,0,T,ber between
  125. F,29,11,0,0,T, 10 and 99
  126. G,29,11,0,0,T,at cell "C3
  127. H,29,11,0,0,T,6". The
  128. A,30,5,26,0,N,26
  129. B,30,6,1.25,2,N,1.25
  130. D,30,11,0,0,T,LOOKUP func
  131. E,30,11,0,0,T,tion at cel
  132. F,30,11,0,0,T,l "D36" wil
  133. G,30,11,0,0,T,l then retu
  134. H,30,11,0,0,T,rn the Rate
  135. A,31,5,27,0,N,27
  136. B,31,6,1.35,2,N,1.35
  137. D,31,11,30,0,T,located in 
  138. E,31,11,0,0,T,the Cell to
  139. F,31,11,0,0,T, right of t
  140. G,31,11,0,0,T,he Look up 
  141. H,31,11,0,0,T,key number.
  142. A,32,5,28,0,N,28
  143. B,32,6,1.45,2,N,1.45
  144. D,32,11,0,0,T,If a number
  145. E,32,11,0,0,T, is not fou
  146. F,32,11,0,0,T,nd in the r
  147. G,32,11,0,0,T,ange of cel
  148. H,32,11,0,0,T,ls then the
  149. A,33,5,29,0,N,29
  150. B,33,6,1.55,2,N,1.55
  151. D,33,11,0,0,T,nearest les
  152. E,33,11,0,0,T,sor number 
  153. F,33,11,0,0,T,is used or 
  154. G,33,11,0,0,T,a zero is r
  155. H,33,11,0,0,T,eturned.
  156. A,34,5,30,0,N,30
  157. B,34,6,1.75,2,N,1.75
  158. D,34,11,0,0,T,For example
  159. E,34,11,0,0,T, in our sam
  160. F,34,11,0,0,T,ple number 
  161. G,34,11,15,0,T,15 would re
  162. H,34,11,0,0,T,turn 0.95
  163. A,35,5,31,0,N,31
  164. B,35,6,1.80,2,N,1.80
  165. D,35,11,0,0,T,and number 
  166. E,35,11,0,0,T,9 would ret
  167. F,35,11,0,0,T,urn a zero.
  168. A,36,5,32,0,N,32
  169. B,36,6,1.85,2,N,1.85
  170. C,36,11,33,0,N,33
  171. D,36,11,1.95,2,F,(LOOKUP(C36,A29:A40)
  172. E,36,11,0,0,T, <- The LOO
  173. F,36,11,0,0,T,KUP functio
  174. G,36,11,0,0,T,n is in cel
  175. H,36,11,0,0,T,l "D36".
  176. A,37,5,33,0,N,33
  177. B,37,6,1.95,2,N,1.95
  178. E,37,11,0,0,T,    The loo
  179. F,37,11,0,0,T,kup key num
  180. G,37,11,0,0,T,ber is in c
  181. H,37,11,0,0,T,ell "E36".
  182. A,38,5,34,0,N,34
  183. B,38,6,2.05,2,N,2.05
  184. D,38,11,0,0,T,The LOOKUP
  185. E,38,11,0,0,T,function ma
  186. F,38,11,0,0,T,y not be us
  187. G,38,11,0,0,T,ed within a
  188. H,38,11,0,0,T, formula
  189. A,39,5,35,0,N,35
  190. B,39,6,2.25,2,N,2.25
  191. D,39,11,0,0,T,but it may 
  192. E,39,11,0,0,T,be referenc
  193. F,39,11,0,0,T,ed as in ce
  194. G,39,11,0,0,T,ll "H39" ->
  195. H,39,11,195.00,2,F,(100 X D36)
  196. A,40,5,99,0,N,99
  197. B,40,6,55.00,2,N,55
  198. C,40,11,0,0,T,    Press t
  199. D,40,11,0,0,T,he "Pg Dn" 
  200. E,40,11,0,0,T,key for nex
  201. F,40,11,0,0,T,t example:
  202. D,41,11,0,0,T,The Minimum
  203. E,41,11,0,0,T, Function
  204. C,43,11,0,0,T,The Minimum
  205. D,43,11,0,0,T, function r
  206. E,43,11,0,0,T,eturns the 
  207. F,43,11,0,0,T,lessor of t
  208. G,43,11,0,0,T,wo argument
  209. H,43,11,0,0,T,s.
  210. C,44,11,0,0,T,The argumen
  211. D,44,11,0,0,T,ts be cell 
  212. E,44,11,0,0,T,references 
  213. F,44,11,0,0,T,or numbers.
  214. C,46,11,0,0,T,To find the
  215. D,46,11,0,0,T, lessor val
  216. E,46,11,0,0,T,ue of our s
  217. F,46,11,0,0,T,ample cells
  218. G,46,11,0,0,T, at cell "A
  219. H,46,11,0,0,T,51" and
  220. C,47,11,0,0,T,cell "B51" 
  221. D,47,11,0,0,T,you would u
  222. E,47,11,0,0,T,sed the fun
  223. F,47,11,0,0,T,ction locat
  224. G,47,11,0,0,T,ed in cell 
  225. H,47,11,0,0,T,"C51".
  226. C,48,11,0,0,T,The minimum
  227. D,48,11,0,0,T, function m
  228. E,48,11,0,0,T,ay be used 
  229. F,48,11,0,0,T,within a fo
  230. G,48,11,0,0,T,rmula as sh
  231. H,48,11,0,0,T,ow in
  232. C,49,11,0,0,T,cell "E51".
  233. A,51,5,5,0,N,5
  234. B,51,6,9,0,N,9
  235. C,51,11,5,0,F,(A51 < B51)
  236. E,51,11,50,0,F,10 X (A51 < B51)
  237. F,51,11,0,0,T, <- The for
  238. G,51,11,0,0,T,mula in cel
  239. H,51,11,0,0,T,l "E51"
  240. F,52,11,0,0,T,is 10 times
  241. G,52,11,0,0,T, the lessor
  242. H,52,11,0,0,T, of cell
  243. F,53,11,0,0,T,"A51" or "B
  244. G,53,11,0,0,T,51".
  245. D,55,11,0,0,T,The Maximum
  246. E,55,11,0,0,T, Function
  247. C,57,11,0,0,T,The Maximum
  248. D,57,11,0,0,T, function o
  249. E,57,11,0,0,T,perates the
  250. F,57,11,0,0,T, same as th
  251. G,57,11,0,0,T,e minimum e
  252. H,57,11,0,0,T,xcept
  253. C,58,11,0,0,T,it returns
  254. D,58,11,0,0,T,the greater
  255. E,58,11,0,0,T, value.
  256. F,58,11,0,0,T,The formula
  257. G,58,11,0,0,T, in cell "F
  258. H,58,11,0,0,T,59" shows
  259. C,59,11,0,0,T,the greater
  260. D,59,11,0,0,T, number tim
  261. E,59,11,0,0,T,es 10.  ->
  262. F,59,11,90,0,F,(10 X (A51 > B51))
  263. A,60,5,0,0,T,Press
  264. B,60,6,0,0,T, the"P
  265. C,60,11,0,0,T,g Dn" key f
  266. D,60,11,0,0,T,or next exa
  267. E,60,11,0,0,T,mple.
  268. D,62,11,0,0,T,The Average
  269. E,62,11,0,0,T, Function
  270. C,64,11,0,0,T,The Average
  271. D,64,11,0,0,T, function r
  272. E,64,11,0,0,T,eturns the 
  273. F,64,11,0,0,T,average of 
  274. G,64,11,0,0,T,a sum of nu
  275. H,64,11,0,0,T,mbers.
  276. A,65,5,2,0,N,2
  277. C,65,11,0,0,T,The example
  278. D,65,11,0,0,T, function i
  279. E,65,11,0,0,T,s located i
  280. F,65,11,0,0,T,n cell "C70
  281. G,65,11,0,0,T,". This fun
  282. H,65,11,0,0,T,ction
  283. A,66,5,4,0,N,4
  284. C,66,11,0,0,T,maybe used
  285. D,66,11,0,0,T,directly wi
  286. E,66,11,0,0,T,thin a form
  287. F,66,11,0,0,T,ula.
  288. A,67,5,3,0,N,3
  289. A,68,5,5,0,N,5
  290. A,69,5,6,0,N,6
  291. A,70,5,3,0,N,3
  292. C,70,11,3.80,2,F,(AVG(A65 : A74)
  293. D,70,11,0,0,T, <- average
  294. E,70,11,0,0,T, of numbers
  295. F,70,11,0,0,T, in cells "
  296. G,70,11,0,0,T,A65" thru "
  297. H,70,11,0,0,T,A74"
  298. A,71,5,3,0,N,3
  299. A,72,5,7,0,N,7
  300. A,73,5,3,0,N,3
  301. A,74,5,2,0,N,2
  302. D,74,11,0,0,T,The Sum Tot
  303. E,74,11,0,0,T,al Function
  304. A,76,5,38,0,F,(A65 : A74)
  305. B,76,6,0,0,T, <--
  306. C,76,11,0,0,T,The sum fun
  307. D,76,11,0,0,T,ction adds 
  308. E,76,11,0,0,T,all numbers
  309. F,76,11,0,0,T, in a range
  310. G,76,11,0,0,T, and return
  311. H,76,11,0,0,T,s the
  312. C,77,11,0,0,T,total. The 
  313. D,77,11,0,0,T,example sum
  314. E,77,11,0,0,T, function i
  315. F,77,11,0,0,T,s located i
  316. G,77,11,0,0,T,n cell "A76
  317. H,77,11,0,0,T,". This
  318. C,78,11,0,0,T,function ma
  319. D,78,11,0,0,T,ybe used di
  320. E,78,11,0,0,T,rectly with
  321. F,78,11,0,0,T,in a formul
  322. G,78,11,0,0,T,a.
  323. C,80,11,0,0,T,Press the"P
  324. D,80,11,0,0,T,g Dn" key f
  325. E,80,11,0,0,T,or the next
  326. F,80,11,0,0,T, example
  327. C,81,11,0,0,T,Creating ve
  328. D,81,11,0,0,T,rtical and 
  329. E,81,11,0,0,T,horizontal 
  330. F,81,11,0,0,T,bar charts
  331. C,83,11,0,0,T,Pressing Fu
  332. D,83,11,0,0,T,nction key 
  333. E,83,11,0,0,T,"F6" create
  334. F,83,11,0,0,T,s the follo
  335. G,83,11,0,0,T,wing: ->
  336. H,83,11,0,0,T, ▒▒▒▒▒▒▒▒▒▒
  337. C,84,11,0,0,T,Pressing Fu
  338. D,84,11,0,0,T,nction key 
  339. E,84,11,0,0,T,"F8" create
  340. F,84,11,0,0,T,s the follo
  341. G,84,11,0,0,T,wing: ->
  342. H,84,11,0,0,T, ░░░░░░░░░░
  343. C,85,11,0,0,T,Pressing Fu
  344. D,85,11,0,0,T,nction key 
  345. E,85,11,0,0,T,"F10 create
  346. F,85,11,0,0,T,s the follo
  347. G,85,11,0,0,T,wing: ->
  348. H,85,11,0,0,T, ▓▓▓▓▓▓▓▓▓▓
  349. C,88,11,0,0,T,Pressing Fu
  350. D,88,11,0,0,T,nction key 
  351. E,88,11,0,0,T,"F5" create
  352. F,88,11,0,0,T,s the follo
  353. G,88,11,0,0,T,wing: ->
  354. H,88,11,0,0,T,▒
  355. C,89,11,0,0,T,Pressing Fu
  356. D,89,11,0,0,T,nction key 
  357. E,89,11,0,0,T,"F7" create
  358. F,89,11,0,0,T,s the follo
  359. G,89,11,0,0,T,wing: ->
  360. H,89,11,0,0,T,░
  361. C,90,11,0,0,T,Pressing Fu
  362. D,90,11,0,0,T,nction key 
  363. E,90,11,0,0,T,"F9" create
  364. F,90,11,0,0,T,s the follo
  365. G,90,11,0,0,T,wing: ->
  366. H,90,11,0,0,T,▓
  367. C,98,11,0.00,2,T,Press the "
  368. D,98,11,0.00,2,T,Pg Dn" key 
  369. E,98,11,0.00,2,T,for the nex
  370. F,98,11,0.00,2,T,t example
  371. C,102,11,0.00,2,T,Additional
  372. D,102,11,0.00,2,T,Built in Fu
  373. E,102,11,0.00,2,T,nctions
  374. G,103,11,0.00,2,T, Functions
  375. H,103,11,0.00,2,T,    Cell
  376. G,104,11,0.00,2,T,  Results
  377. H,104,11,0.00,2,T, Reference
  378. B,106,6,0.00,2,T,ABS  -
  379. C,106,11,0.00,2,T, Returns th
  380. D,106,11,0.00,2,T,e absolute 
  381. E,106,11,0.00,2,T,value of a 
  382. F,106,11,0.00,2,T,cell - ie->
  383. G,106,11,12.65,2,F,(ABS(H106))
  384. H,106,11,-12.65,2,N,-12.65
  385. B,108,6,0.00,2,T,INT  -
  386. C,108,11,0.00,2,T, Returns th
  387. D,108,11,0.00,2,T,e integer v
  388. E,108,11,0.00,2,T,alue of a c
  389. F,108,11,0.00,2,T,ell  - ie->
  390. G,108,11,12.00,2,F,(INT(H108))
  391. H,108,11,12.55,2,N,12.55
  392.